 create table pu_balancer_b (name nvarchar(50) null /*名称*/,
code nvarchar(50) null /*编码*/,
bdef20 nvarchar(101) null /*自定义项20*/,
bdef19 nvarchar(101) null /*自定义项19*/,
bdef18 nvarchar(101) null /*自定义项18*/,
bdef17 nvarchar(101) null /*自定义项17*/,
bdef16 nvarchar(101) null /*自定义项16*/,
bdef15 nvarchar(101) null /*自定义项15*/,
bdef14 nvarchar(101) null /*自定义项14*/,
bdef13 nvarchar(101) null /*自定义项13*/,
bdef12 nvarchar(101) null /*自定义项12*/,
bdef11 nvarchar(101) null /*自定义项11*/,
bdef10 nvarchar(101) null /*自定义项10*/,
bdef9 nvarchar(101) null /*自定义项9*/,
bdef8 nvarchar(101) null /*自定义项8*/,
bdef7 nvarchar(101) null /*自定义项7*/,
bdef6 nvarchar(101) null /*自定义项6*/,
bdef5 nvarchar(101) null /*自定义项5*/,
bdef4 nvarchar(101) null /*自定义项4*/,
bdef3 nvarchar(101) null /*自定义项3*/,
bdef2 nvarchar(101) null /*自定义项2*/,
bdef1 nvarchar(101) null /*自定义项1*/,
budget nvarchar(50) null /*预算数*/,
endingcredit nvarchar(50) null /*期末贷方*/,
endingdebit nvarchar(50) null /*期末借方*/,
currentcredit nvarchar(50) null /*本期贷方*/,
currentdebit nvarchar(50) null /*本期借方*/,
openingcredit nvarchar(50) null /*期初贷方*/,
openingdebit nvarchar(50) null /*期初借方*/,
accounting nvarchar(50) null /*会计期间*/,
currency nvarchar(50) null /*币种*/,
spare2 nvarchar(50) null /*spare2*/,
spare1 nvarchar(50) null /*spare1*/,
iceorg nvarchar(50) null /*往来公司*/,
project nvarchar(50) null /*项目*/,
subject nvarchar(50) null /*科目*/,
ncsubject nvarchar(50) null /*NC科目*/,
business nvarchar(50) null /*BusinessSegment*/,
building nvarchar(50) null /*楼栋*/,
depar nvarchar(50) null /*部门*/,
org nvarchar(50) null /*公司*/,
ledgename nvarchar(50) null /*LedgerName*/,
identification nvarchar(50) null /*关帐标识*/,
exportdate nvarchar(50) null /*导出日期*/,
edti_date nchar(19) null /*修改日期*/,
edit_user nvarchar(20) default '~' null /*修改人*/,
in_date nchar(19) null /*导入日期*/,
in_user nvarchar(20) default '~' null /*导入人*/,
pk_org nvarchar(20) default '~' null /*组织*/,
pk_org_v nvarchar(20) default '~' null /*组织版本*/,
pk_group nvarchar(20) default '~' null /*集团*/,
pk_head nchar(20) not null /*科目余额报表表主键*/,
ts nchar(19) default convert(char(19),getdate(),20) null /*null*/,
dr smallint null /*null*/,
 constraint pu_balancer_b_PK  primary key (pk_head)
)

go

